﻿create procedure [dbo].[usp_TargetSiteUpdate]
	@TargetSiteId int
	, @ConcurrencyId timestamp
	, @IsAbstract bit
	, @IsAssembly bit
	, @IsConstructor bit
	, @IsFamily bit
	, @IsFamilyAndAssembly bit
	, @IsFamilyOrAssembly bit
	, @IsFinal bit
	, @IsHideBySignature bit
	, @IsPrivate bit
	, @IsPublic bit
	, @IsSpecialName bit
	, @IsStatic bit
	, @IsVirtual bit
as

begin try
	
	begin transaction
	
		update [dbo].[TargetSite]
		set
			IsAbstract = @IsAbstract
			, IsAssembly = @IsAssembly
			, IsConstructor = @IsConstructor
			, IsFamily = @IsFamily
			, IsFamilyAndAssembly = @IsFamilyAndAssembly
			, IsFamilyOrAssembly = @IsFamilyOrAssembly
			, IsFinal = @IsFinal
			, IsHideBySignature = @IsHideBySignature
			, IsPrivate = @IsPrivate
			, IsPublic = @IsPublic
			, IsSpecialName = @IsSpecialName
			, IsStatic = @IsStatic
			, IsVirtual = @IsVirtual	
		where TargetSiteId = @TargetSiteId and ConcurrencyId = @ConcurrencyId
		
	commit transaction

end try
	
begin catch
	if @@trancount > 0
	begin
		rollback transaction;
	end
	execute [dbo].[usp_SqlErrorInsert]
end catch


